import xlrd
class readexcel:
    def read(self,path,index=0):
        work = xlrd.open_workbook(path)
        table = work.sheet_by_index(index)
        ls = []
        for i in range(table.nrows):
            ls.append(table.row_values(i))
        return ls
# path = r'C:\Users\Administrator\Desktop\auto_script.xlsx'
# print(readexcel().read(path))